Bentley Map requires the following for proper query of SQL Server data.

• Tables must be of one data type; point line or polygon. Mixed data types are not permitted.

Notes regarding SQL Server operation with Bentley Map:

• SQL Server does not explicitly restrict tables from having more than one geometry type. It is up to the application to make sure that only one spatial data type is posted to the spatial table
• Bentley Map will not post the wrong spatial data type to a table correctly registered in Bentley Geospatial Administrator
• If a table contains spatial data types that do not correspond to the spatial type noted in Bentley Geospatial Administrator, it will not be queried.